package smartcommunityserver.mapper;



import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import smartcommunityserver.bean.DitucountBean;
import smartcommunityserver.bean.NumcountBean;

import java.util.List;

/**
 * @author renmin
 */
@Mapper
public interface DitucountMapper {
    @Select("SELECT\n" +
            "    districtName\n" +
            ",count(communityName) as num\n" +
            "FROM dws_sca.dws_summary_entrance_guard_log\n" +
            "GROUP BY districtName;")
    List<DitucountBean> getditucountBean();
}
